﻿CREATE TABLE [acms].[ExceptionLog] (
    [Id]                    INT            IDENTITY (1, 1) NOT NULL,
    [ServerName]            VARCHAR (50)   NULL,
    [ApplicationRoot]       VARCHAR (50)   NULL,
    [Url]                   VARCHAR (255)  NULL,
    [RawUrl]                VARCHAR (255)  NULL,
    [PostId]                INT            NULL,
    [SiteId]                INT            NULL,
    [ExceptionType]         VARCHAR (255)  NULL,
    [ExceptionMessage]      VARCHAR (2000) NULL,
    [InnerExceptionType]    VARCHAR (255)  NULL,
    [InnerExceptionMessage] VARCHAR (2000) NULL,
    [Source]                VARCHAR (100)  NULL,
    [StackTrace]            VARCHAR (2000) NULL,
    [Created]               DATETIME       NOT NULL
);

